<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Data type assignments and comparison, sorting, and ordering</title>
<link type="text/css" href="../../skin/page.css" rel="stylesheet">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<!--================= start Navigation Path ==================-->
<table summary="navigation path" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td nowrap="nowrap" valign="middle" bgcolor="#CFDCED" height="20"><img height="1" width="5" alt="" src="../../skin/images/spacer.gif" class="spacer"><!--===== breadcrumb trail (javascript-generated) ====--><font size="2" face="Arial, Helvetica, Sans-serif"><script src="../../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script></font></td>
</tr>
<tr>
<td bgcolor="#4C6C8F" height="2"><img height="2" width="2" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
<!--================= end Navigation Path ==================-->
<!--================= start Banner ==================-->
<table summary="header with logos" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<!--================= start Group Logo ==================-->
<td bgcolor="#294563"><a href="http://incubator.apache.org"><img border="0" class="logoImage" alt="" src="../../resources/images/apache-incubator.png" title="Derby is a zero admin java based embedded database."></a></td>
<!--================= end Group Logo ==================-->
<!--================= start Project Logo ==================--><td width="100%" align="center" bgcolor="#294563"><a href="http://incubator.apache.org/derby/"><img border="0" class="logoImage" alt="Derby" src="../../images/derby-logo.jpg" title="Derby is a zero admin java based embedded database."></a></td>
<!--================= end Project Logo ==================-->
<!--================= start Search ==================--><td valign="top" rowspan="2" bgcolor="#294563">
<form target="_blank" action="http://www.google.com/search" method="get">
<table summary="search" border="0" cellspacing="0" cellpadding="0" bgcolor="#4C6C8F">
<tr>
<td colspan="3"><img height="10" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td nowrap="nowrap"><input value="incubator.apache.org" name="sitesearch" type="hidden"><input size="15" name="q" id="query" type="text"><img height="1" width="5" alt="" src="../../skin/images/spacer.gif" class="spacer"><input name="Search" value="Search" type="submit">
<br>
<font face="Arial, Helvetica, Sans-serif" size="2" color="white">
                      the Derby site
                      
                      
                    </font></td><td><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td><img alt="" border="0" height="10" width="9" src="../../skin/images/search-left.gif"></td><td><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td><img alt="" border="0" height="10" width="9" src="../../skin/images/search-right.gif"></td>
</tr>
</table>
</form>
</td>
<!--================= start Search ==================--><td bgcolor="#294563"><img height="10" width="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td valign="bottom" bgcolor="#294563" colspan="2">
<!--================= start Tabs ==================-->
<div class="tab">
<table summary="tab bar" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="6"><img alt="" height="8" width="6" src="../../skin/images/spacer.gif"></td><td valign="bottom">
<table summary="non selected tab" style="height: 1.6em" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-left.gif"></td><td valign="middle" bgcolor="#B2C4E0"><a class="base-not-selected" href="../../index.html">Home</a></td><td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-right.gif"></td>
</tr>
<tr>
<td colspan="3" height="1"></td>
</tr>
</table>
</td><td width="6"><img alt="" height="8" width="6" src="../../skin/images/spacer.gif"></td><td valign="bottom">
<table summary="selected tab" style="height: 1.8em" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="5" bgcolor="#4C6C8F"><img height="5" width="5" alt="" src="../../skin/images/tabSel-left.gif"></td><td valign="middle" bgcolor="#4C6C8F"><font color="#ffffff" size="2" face="Arial, Helvetica, Sans-serif"><b><a class="base-selected" href="../../manuals/index.html">Manuals</a></b></font></td><td valign="top" width="5" bgcolor="#4C6C8F"><img height="5" width="5" alt="" src="../../skin/images/tabSel-right.gif"></td>
</tr>
</table>
</td><td width="6"><img alt="" height="8" width="6" src="../../skin/images/spacer.gif"></td><td valign="bottom">
<table summary="non selected tab" style="height: 1.6em" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-left.gif"></td><td valign="middle" bgcolor="#B2C4E0"><a class="base-not-selected" href="../../papers/index.html">Papers</a></td><td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-right.gif"></td>
</tr>
<tr>
<td colspan="3" height="1"></td>
</tr>
</table>
</td>
</tr>
</table>
</div>
<!--================= end Tabs ==================-->
</td><td bgcolor="#294563"><img alt="" width="1" height="1" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td bgcolor="#4C6C8F" colspan="4"><img width="1" height="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
<!--================= end Banner ==================-->
<!--================= start Menu, NavBar, Content ==================-->
<table summary="page content" bgcolor="#ffffff" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top">
<table summary="menu" border="0" cellspacing="0" cellpadding="0">
<tr>
<!--================= start left top NavBar ==================-->
<td rowspan="3" valign="top">
<table summary="blue line" border="0" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td bgcolor="#CFDCED"><font color="#4C6C8F" size="4" face="Arial, Helvetica, Sans-serif">&nbsp;</font></td>
</tr>
<tr>
<td bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
</td>
<!--================= end left top NavBar ==================--><td bgcolor="#294563"><img width="1" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td valign="bottom" bgcolor="#4C6C8F"><img width="10" height="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td nowrap="nowrap" valign="top" bgcolor="#4C6C8F">
<!--================= start Menu items ==================-->
<div class="menu">
<ul>
<li>
<font color="#CFDCED">Manuals</font>
<ul>
     
<li>
<a href="../../manuals/index.html">About</a>
</li>
     
<li>
<font color="#CFDCED">Getting Started</font>
<ul>
         
<li>
<a href="../../manuals/getstart/gspr02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/getstart/gspr40.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>
     
<li>
<font color="#CFDCED">Reference Manual</font>
<ul>
         
<li>
<a href="../../manuals/reference/sqlj02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/reference/sqlj275.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>

     
<li>
<font color="#CFDCED">Developer's Guide</font>
<ul>
         
<li>
<a href="../../manuals/develop/develop02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/develop/develop157.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>
     
<li>
<font color="#CFDCED">Tuning Derby</font>
<ul>
         
<li>
<a href="../../manuals/tuning/perf02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/tuning/perf121.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>

     
<li>
<font color="#CFDCED">Server &amp; Admin Guide</font>
<ul>
         
<li>
<a href="../../manuals/admin/hubprnt02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/admin/hubprnt65.html" title="Index">Index</a>
</li>
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
        
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
    
</ul>
</li>

    
<li>
<font color="#CFDCED">Tools &amp; Utility Guide</font>
<ul>
         
<li>
<a href="../../manuals/tools/tools02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/tools/tools113.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
    
</ul>
</li>
  
</ul>
</li>
</ul>
</div>
<!--================= end Menu items ==================-->
</td><td valign="bottom" bgcolor="#4C6C8F"><img width="10" height="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td bgcolor="#294563"><img width="1" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td valign="bottom" align="left" colspan="2" rowspan="2" bgcolor="#4C6C8F"><img height="10" width="10" border="0" alt="" src="../../skin/images/menu-left.gif"></td><td bgcolor="#4C6C8F"><img height="10" width="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td valign="bottom" align="right" colspan="2" rowspan="2" bgcolor="#4C6C8F"><img height="10" width="10" border="0" alt="" src="../../skin/images/menu-right.gif"></td>
</tr>
<tr>
<td height="1" bgcolor="#294563"><img width="1" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
</td><td valign="top" width="100%">
<table summary="content" width="100%" border="0" cellpadding="0" cellspacing="0">
<!--================= start middle NavBar ==================-->
<tr>
<td colspan="4" bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td align="left" width="10" bgcolor="#CFDCED"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td align="left" width="50%" bgcolor="#CFDCED"><font color="#4C6C8F" size="3" face="Arial, Helvetica, Sans-serif">
                &nbsp;
                
                </font><img width="10" height="8" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td align="right" width="50%" bgcolor="#CFDCED"><font color="#4C6C8F" size="3" face="Arial, Helvetica, Sans-serif">
                &nbsp;
                
                </font><img width="10" height="8" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td width="10" bgcolor="#CFDCED"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td colspan="4" bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<!--================= end middle NavBar ==================-->
<!--================= start Content==================-->
<tr>
<td align="left" width="10"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td colspan="2" align="left" width="100%">
<div class="content">
<table class="title" summary="">
<tr>
<td valign="middle">
<h1>Data type assignments and comparison, sorting, and ordering</h1>
</td>
</tr>
</table>
<ul class="minitoc">
<li>
<a href="#Data+type+assignments+and+comparison%2C+sorting%2C+and+ordering">Data type assignments and comparison, sorting, and ordering</a>
</li>
</ul>
<a name="N1003A"></a><a name="Data+type+assignments+and+comparison%2C+sorting%2C+and+ordering"></a>
<h3>Data type assignments and comparison, sorting, and ordering</h3>
<div style="margin-left: 0 ; border: 2px">
<br>
<p>
<strong>Table 5. Assignments allowed by Derby</strong>
<br>
</p>
<table class="ForrestTable" cellspacing="1" cellpadding="4">
<tr>
<td colspan="19" width="100%">This table displays valid assignments between data types in Derby. A "Y" indicates that the assignment is valid.</td>
</tr>
<tr>
<th><a name="WQ36"></a>Types</th><th><a name="WQ37"></a>S<br>M<br>A<br>L<br>L<br>I<br>N<br>T<br>
</th><th><a name="WQ38"></a>I<br>N<br>T<br>E<br>G<br>E<br>R<br>
</th><th><a name="WQ39"></a>B<br>I<br>G<br>I<br>N<br>T<br>
</th><th><a name="WQ40"></a>D<br>E<br>C<br>I<br>M<br>A<br>L<br>
</th><th><a name="WQ41"></a>R<br>E<br>A<br>L<br>
</th><th><a name="WQ42"></a>D<br>O<br>U<br>B<br>L<br>E<br>
</th><th><a name="WQ43"></a>F<br>L<br>O<br>A<br>T<br>
</th><th><a name="WQ44"></a>C<br>H<br>A<br>R<br>
</th><th><a name="WQ45"></a>V<br>A<br>R<br>C<br>H<br>A<br>R<br>
</th><th><a name="WQ46"></a>L<br>O<br>N<br>G<br>
<p>
<br>V<br>A<br>R<br>C<br>H<br>A<br>R<br>
</p>
</th><th><a name="WQ47"></a>C<br>H<br>A<br>R<br>
<p>
<br>F<br>O<br>R<br>
</p>
<p>
<br>B<br>I<br>T<br>
</p>
<p>
<br>D<br>A<br>T<br>A<br>
</p>
</th><th><a name="WQ48"></a>V<br>A<br>R<br>C<br>H<br>A<br>R<br>
<p>
<br>F<br>O<br>R<br>
</p>
<p>
<br>B<br>I<br>T<br>
</p>
<p>
<br>D<br>A<br>T<br>A<br>
</p>
</th><th><a name="WQ49"></a>L<br>O<br>N<br>G<br>
<p>
<br>V<br>A<br>R<br>C<br>H<br>A<br>R<br>
</p>
<p>
<br>F<br>O<br>R<br>
</p>
<p>
<br>B<br>I<br>T<br>
</p>
<p>
<br>D<br>A<br>T<br>A<br>
</p>
</th><th><a name="WQ50"></a>C<br>L<br>O<br>B<br>
</th><th><a name="WQ51"></a>B<br>L<br>O<br>B<br>
</th><th><a name="WQ52"></a>D<br>A<br>T<br>E<br>
</th><th><a name="WQ53"></a>T<br>I<br>M<br>E<br>
</th><th><a name="WQ54"></a>T<br>I<br>M<br>E<br>S<br>T<br>A<br>M<br>P<br>
</th>
</tr>
<tr>
<td headers="WQ36" width="19%">SMALL INT</td><td headers="WQ37" width="5%">Y</td><td headers="WQ38" width="5%">Y</td><td headers="WQ39" width="5%">Y</td><td headers="WQ40" width="5%">Y</td><td headers="WQ41" width="4%">Y</td><td headers="WQ42" width="5%">Y</td><td headers="WQ43" width="5%">Y</td><td headers="WQ44" width="5%">--</td><td headers="WQ45" width="5%">--</td><td headers="WQ46" width="4%">--</td><td headers="WQ47" width="5%">--</td><td headers="WQ48" width="5%">--</td><td headers="WQ49" width="4%">--</td><td headers="WQ50" width="5%">--</td><td headers="WQ51" width="5%">--</td><td headers="WQ52" width="5%">--</td><td headers="WQ53" width="5%">--</td><td headers="WQ54" width="5%">--</td>
</tr>
<tr>
<td headers="WQ36" width="19%">INTEGER</td><td headers="WQ37" width="5%">Y</td><td headers="WQ38" width="5%">Y</td><td headers="WQ39" width="5%">Y</td><td headers="WQ40" width="5%">Y</td><td headers="WQ41" width="4%">Y</td><td headers="WQ42" width="5%">Y</td><td headers="WQ43" width="5%">Y</td><td headers="WQ44" width="5%">--</td><td headers="WQ45" width="5%">--</td><td headers="WQ46" width="4%">--</td><td headers="WQ47" width="5%">--</td><td headers="WQ48" width="5%">--</td><td headers="WQ49" width="4%">--</td><td headers="WQ50" width="5%">--</td><td headers="WQ51" width="5%">--</td><td headers="WQ52" width="5%">--</td><td headers="WQ53" width="5%">--</td><td headers="WQ54" width="5%">--</td>
</tr>
<tr>
<td headers="WQ36" width="19%">BIGINT</td><td headers="WQ37" width="5%">Y</td><td headers="WQ38" width="5%">Y</td><td headers="WQ39" width="5%">Y</td><td headers="WQ40" width="5%">Y</td><td headers="WQ41" width="4%">Y</td><td headers="WQ42" width="5%">Y</td><td headers="WQ43" width="5%">Y</td><td headers="WQ44" width="5%">--</td><td headers="WQ45" width="5%">--</td><td headers="WQ46" width="4%">--</td><td headers="WQ47" width="5%">--</td><td headers="WQ48" width="5%">--</td><td headers="WQ49" width="4%">--</td><td headers="WQ50" width="5%">--</td><td headers="WQ51" width="5%">--</td><td headers="WQ52" width="5%">--</td><td headers="WQ53" width="5%">--</td><td headers="WQ54" width="5%">--</td>
</tr>
<tr>
<td headers="WQ36" width="19%">DECIMAL</td><td headers="WQ37" width="5%">Y</td><td headers="WQ38" width="5%">Y</td><td headers="WQ39" width="5%">Y</td><td headers="WQ40" width="5%">Y</td><td headers="WQ41" width="4%">Y</td><td headers="WQ42" width="5%">Y</td><td headers="WQ43" width="5%">Y</td><td headers="WQ44" width="5%">--</td><td headers="WQ45" width="5%">--</td><td headers="WQ46" width="4%">--</td><td headers="WQ47" width="5%">--</td><td headers="WQ48" width="5%">--</td><td headers="WQ49" width="4%">--</td><td headers="WQ50" width="5%">--</td><td headers="WQ51" width="5%">--</td><td headers="WQ52" width="5%">--</td><td headers="WQ53" width="5%">--</td><td headers="WQ54" width="5%">--</td>
</tr>
<tr>
<td headers="WQ36" width="19%">REAL</td><td headers="WQ37" width="5%">Y</td><td headers="WQ38" width="5%">Y</td><td headers="WQ39" width="5%">Y</td><td headers="WQ40" width="5%">Y</td><td headers="WQ41" width="4%">Y</td><td headers="WQ42" width="5%">Y</td><td headers="WQ43" width="5%">Y</td><td headers="WQ44" width="5%">--</td><td headers="WQ45" width="5%">--</td><td headers="WQ46" width="4%">--</td><td headers="WQ47" width="5%">--</td><td headers="WQ48" width="5%">--</td><td headers="WQ49" width="4%">--</td><td headers="WQ50" width="5%">--</td><td headers="WQ51" width="5%">--</td><td headers="WQ52" width="5%">--</td><td headers="WQ53" width="5%">--</td><td headers="WQ54" width="5%">--</td>
</tr>
<tr>
<td headers="WQ36" width="19%">DOUBLE</td><td headers="WQ37" width="5%">Y</td><td headers="WQ38" width="5%">Y</td><td headers="WQ39" width="5%">Y</td><td headers="WQ40" width="5%">Y</td><td headers="WQ41" width="4%">Y</td><td headers="WQ42" width="5%">Y</td><td headers="WQ43" width="5%">Y</td><td headers="WQ44" width="5%">--</td><td headers="WQ45" width="5%">--</td><td headers="WQ46" width="4%">--</td><td headers="WQ47" width="5%">--</td><td headers="WQ48" width="5%">--</td><td headers="WQ49" width="4%">--</td><td headers="WQ50" width="5%">--</td><td headers="WQ51" width="5%">--</td><td headers="WQ52" width="5%">--</td><td headers="WQ53" width="5%">--</td><td headers="WQ54" width="5%">--</td>
</tr>
<tr>
<td headers="WQ36" width="19%">FLOAT</td><td headers="WQ37" width="5%">Y</td><td headers="WQ38" width="5%">Y</td><td headers="WQ39" width="5%">Y</td><td headers="WQ40" width="5%">Y</td><td headers="WQ41" width="4%">Y</td><td headers="WQ42" width="5%">Y</td><td headers="WQ43" width="5%">Y</td><td headers="WQ44" width="5%">--</td><td headers="WQ45" width="5%">--</td><td headers="WQ46" width="4%">--</td><td headers="WQ47" width="5%">--</td><td headers="WQ48" width="5%">--</td><td headers="WQ49" width="4%">--</td><td headers="WQ50" width="5%">--</td><td headers="WQ51" width="5%">--</td><td headers="WQ52" width="5%">--</td><td headers="WQ53" width="5%">--</td><td headers="WQ54" width="5%">--</td>
</tr>
<tr>
<td headers="WQ36" width="19%">CHAR</td><td headers="WQ37" width="5%">--</td><td headers="WQ38" width="5%">--</td><td headers="WQ39" width="5%">--</td><td headers="WQ40" width="5%">--</td><td headers="WQ41" width="4%">--</td><td headers="WQ42" width="5%">--</td><td headers="WQ43" width="5%">--</td><td headers="WQ44" width="5%">Y</td><td headers="WQ45" width="5%">Y</td><td headers="WQ46" width="4%">Y</td><td headers="WQ47" width="5%">--</td><td headers="WQ48" width="5%">--</td><td headers="WQ49" width="4%">--</td><td headers="WQ50" width="5%">Y</td><td headers="WQ51" width="5%">--</td><td headers="WQ52" width="5%">Y</td><td headers="WQ53" width="5%">Y</td><td headers="WQ54" width="5%">Y</td>
</tr>
<tr>
<td headers="WQ36" width="19%">VARCHAR</td><td headers="WQ37" width="5%">--</td><td headers="WQ38" width="5%">--</td><td headers="WQ39" width="5%">--</td><td headers="WQ40" width="5%">--</td><td headers="WQ41" width="4%">--</td><td headers="WQ42" width="5%">--</td><td headers="WQ43" width="5%">--</td><td headers="WQ44" width="5%">Y</td><td headers="WQ45" width="5%">Y</td><td headers="WQ46" width="4%">Y</td><td headers="WQ47" width="5%">--</td><td headers="WQ48" width="5%">--</td><td headers="WQ49" width="4%">--</td><td headers="WQ50" width="5%">Y</td><td headers="WQ51" width="5%">--</td><td headers="WQ52" width="5%">Y</td><td headers="WQ53" width="5%">Y</td><td headers="WQ54" width="5%">Y</td>
</tr>
<tr>
<td headers="WQ36" width="19%">LONG VARCHAR</td><td headers="WQ37" width="5%">--</td><td headers="WQ38" width="5%">--</td><td headers="WQ39" width="5%">--</td><td headers="WQ40" width="5%">--</td><td headers="WQ41" width="4%">--</td><td headers="WQ42" width="5%">--</td><td headers="WQ43" width="5%">--</td><td headers="WQ44" width="5%">Y</td><td headers="WQ45" width="5%">Y</td><td headers="WQ46" width="4%">Y</td><td headers="WQ47" width="5%">--</td><td headers="WQ48" width="5%">--</td><td headers="WQ49" width="4%">--</td><td headers="WQ50" width="5%">Y</td><td headers="WQ51" width="5%">--</td><td headers="WQ52" width="5%">--</td><td headers="WQ53" width="5%">--</td><td headers="WQ54" width="5%">--</td>
</tr>
<tr>
<td headers="WQ36" width="19%">CHAR FOR BIT DATA</td><td headers="WQ37" width="5%">--</td><td headers="WQ38" width="5%">--</td><td headers="WQ39" width="5%">--</td><td headers="WQ40" width="5%">--</td><td headers="WQ41" width="4%">--</td><td headers="WQ42" width="5%">--</td><td headers="WQ43" width="5%">--</td><td headers="WQ44" width="5%">--</td><td headers="WQ45" width="5%">--</td><td headers="WQ46" width="4%">--</td><td headers="WQ47" width="5%">Y</td><td headers="WQ48" width="5%">Y</td><td headers="WQ49" width="4%">Y</td><td headers="WQ50" width="5%">--</td><td headers="WQ51" width="5%">--</td><td headers="WQ52" width="5%">--</td><td headers="WQ53" width="5%">--</td><td headers="WQ54" width="5%">--</td>
</tr>
<tr>
<td headers="WQ36" width="19%">VARCHAR FOR BIT DATA</td><td headers="WQ37" width="5%">--</td><td headers="WQ38" width="5%">--</td><td headers="WQ39" width="5%">--</td><td headers="WQ40" width="5%">--</td><td headers="WQ41" width="4%">--</td><td headers="WQ42" width="5%">--</td><td headers="WQ43" width="5%">--</td><td headers="WQ44" width="5%">--</td><td headers="WQ45" width="5%">--</td><td headers="WQ46" width="4%">--</td><td headers="WQ47" width="5%">Y</td><td headers="WQ48" width="5%">Y</td><td headers="WQ49" width="4%">Y</td><td headers="WQ50" width="5%">--</td><td headers="WQ51" width="5%">--</td><td headers="WQ52" width="5%">--</td><td headers="WQ53" width="5%">--</td><td headers="WQ54" width="5%">--</td>
</tr>
<tr>
<td headers="WQ36" width="19%">LONG VARCHAR FOR BIT DATA</td><td headers="WQ37" width="5%">--</td><td headers="WQ38" width="5%">--</td><td headers="WQ39" width="5%">--</td><td headers="WQ40" width="5%">--</td><td headers="WQ41" width="4%">--</td><td headers="WQ42" width="5%">--</td><td headers="WQ43" width="5%">--</td><td headers="WQ44" width="5%">--</td><td headers="WQ45" width="5%">--</td><td headers="WQ46" width="4%">--</td><td headers="WQ47" width="5%">Y</td><td headers="WQ48" width="5%">Y</td><td headers="WQ49" width="4%">Y</td><td headers="WQ50" width="5%">--</td><td headers="WQ51" width="5%">--</td><td headers="WQ52" width="5%">--</td><td headers="WQ53" width="5%">--</td><td headers="WQ54" width="5%">--</td>
</tr>
<tr>
<td headers="WQ36" width="19%">CLOB</td><td headers="WQ37" width="5%">--</td><td headers="WQ38" width="5%">--</td><td headers="WQ39" width="5%">--</td><td headers="WQ40" width="5%">--</td><td headers="WQ41" width="4%">--</td><td headers="WQ42" width="5%">--</td><td headers="WQ43" width="5%">--</td><td headers="WQ44" width="5%">Y</td><td headers="WQ45" width="5%">Y</td><td headers="WQ46" width="4%">Y</td><td headers="WQ47" width="5%">--</td><td headers="WQ48" width="5%">--</td><td headers="WQ49" width="4%">--</td><td headers="WQ50" width="5%">Y</td><td headers="WQ51" width="5%">--</td><td headers="WQ52" width="5%">--</td><td headers="WQ53" width="5%">--</td><td headers="WQ54" width="5%">--</td>
</tr>
<tr>
<td headers="WQ36" width="19%">BLOB</td><td headers="WQ37" width="5%">--</td><td headers="WQ38" width="5%">--</td><td headers="WQ39" width="5%">--</td><td headers="WQ40" width="5%">--</td><td headers="WQ41" width="4%">--</td><td headers="WQ42" width="5%">--</td><td headers="WQ43" width="5%">--</td><td headers="WQ44" width="5%">--</td><td headers="WQ45" width="5%">--</td><td headers="WQ46" width="4%">--</td><td headers="WQ47" width="5%">--</td><td headers="WQ48" width="5%">--</td><td headers="WQ49" width="4%">--</td><td headers="WQ50" width="5%">--</td><td headers="WQ51" width="5%">Y</td><td headers="WQ52" width="5%">--</td><td headers="WQ53" width="5%">--</td><td headers="WQ54" width="5%">--</td>
</tr>
<tr>
<td headers="WQ36" width="19%">DATE</td><td headers="WQ37" width="5%">--</td><td headers="WQ38" width="5%">--</td><td headers="WQ39" width="5%">--</td><td headers="WQ40" width="5%">--</td><td headers="WQ41" width="4%">--</td><td headers="WQ42" width="5%">--</td><td headers="WQ43" width="5%">--</td><td headers="WQ44" width="5%">Y</td><td headers="WQ45" width="5%">Y</td><td headers="WQ46" width="4%">--</td><td headers="WQ47" width="5%">--</td><td headers="WQ48" width="5%">--</td><td headers="WQ49" width="4%">--</td><td headers="WQ50" width="5%">--</td><td headers="WQ51" width="5%">--</td><td headers="WQ52" width="5%">Y</td><td headers="WQ53" width="5%">--</td><td headers="WQ54" width="5%">--</td>
</tr>
<tr>
<td headers="WQ36" width="19%">TIME</td><td headers="WQ37" width="5%">--</td><td headers="WQ38" width="5%">--</td><td headers="WQ39" width="5%">--</td><td headers="WQ40" width="5%">--</td><td headers="WQ41" width="4%">--</td><td headers="WQ42" width="5%">--</td><td headers="WQ43" width="5%">--</td><td headers="WQ44" width="5%">Y</td><td headers="WQ45" width="5%">Y</td><td headers="WQ46" width="4%">--</td><td headers="WQ47" width="5%">--</td><td headers="WQ48" width="5%">--</td><td headers="WQ49" width="4%">--</td><td headers="WQ50" width="5%">--</td><td headers="WQ51" width="5%">--</td><td headers="WQ52" width="5%">--</td><td headers="WQ53" width="5%">Y</td><td headers="WQ54" width="5%">--</td>
</tr>
<tr>
<td headers="WQ36" width="19%">TIME STAMP</td><td headers="WQ37" width="5%">--</td><td headers="WQ38" width="5%">--</td><td headers="WQ39" width="5%">--</td><td headers="WQ40" width="5%">--</td><td headers="WQ41" width="4%">--</td><td headers="WQ42" width="5%">--</td><td headers="WQ43" width="5%">--</td><td headers="WQ44" width="5%">Y</td><td headers="WQ45" width="5%">Y</td><td headers="WQ46" width="4%">--</td><td headers="WQ47" width="5%">--</td><td headers="WQ48" width="5%">--</td><td headers="WQ49" width="4%">--</td><td headers="WQ50" width="5%">--</td><td headers="WQ51" width="5%">--</td><td headers="WQ52" width="5%">--</td><td headers="WQ53" width="5%">--</td><td headers="WQ54" width="5%">Y</td>
</tr>
</table>
<br>
<p>
<strong>Table 6. Comparisons allowed by Derby</strong>
<br>
</p>
<table class="ForrestTable" cellspacing="1" cellpadding="4">
<tr>
<td colspan="19" width="100%">This table displays valid comparisons between data types in Derby. A "Y" indicates that the comparison is allowed.</td>
</tr>
<tr>
<th><a name="WQ56"></a>Types</th><th><a name="WQ57"></a>S<br>M<br>A<br>L<br>L<br>I<br>N<br>T<br>
</th><th><a name="WQ58"></a>I<br>N<br>T<br>E<br>G<br>E<br>R<br>
</th><th><a name="WQ59"></a>B<br>I<br>G<br>I<br>N<br>T<br>
</th><th><a name="WQ60"></a>D<br>E<br>C<br>I<br>M<br>A<br>L<br>
</th><th><a name="WQ61"></a>R<br>E<br>A<br>L<br>
</th><th><a name="WQ62"></a>D<br>O<br>U<br>B<br>L<br>E<br>
</th><th><a name="WQ63"></a>F<br>L<br>O<br>A<br>T<br>
</th><th><a name="WQ64"></a>C<br>H<br>A<br>R<br>
</th><th><a name="WQ65"></a>V<br>A<br>R<br>C<br>H<br>A<br>R<br>
</th><th><a name="WQ66"></a>L<br>O<br>N<br>G<br>
<p>
<br>V<br>A<br>R<br>C<br>H<br>A<br>R<br>
</p>
</th><th><a name="WQ67"></a>C<br>H<br>A<br>R<br>
<p>
<br>F<br>O<br>R<br>
</p>
<p>
<br>B<br>I<br>T<br>
</p>
<p>
<br>D<br>A<br>T<br>A<br>
</p>
</th><th><a name="WQ68"></a>V<br>A<br>R<br>C<br>H<br>A<br>R<br>
<p>
<br>F<br>O<br>R<br>
</p>
<p>
<br>B<br>I<br>T<br>
</p>
<p>
<br>D<br>A<br>T<br>A<br>
</p>
</th><th><a name="WQ69"></a>L<br>O<br>N<br>G<br>
<p>
<br>V<br>A<br>R<br>C<br>H<br>A<br>R<br>
</p>
<p>
<br>F<br>O<br>R<br>
</p>
<p>
<br>B<br>I<br>T<br>
</p>
<p>
<br>D<br>A<br>T<br>A<br>
</p>
</th><th><a name="WQ70"></a>C<br>L<br>O<br>B<br>
</th><th><a name="WQ71"></a>B<br>L<br>O<br>B<br>
</th><th><a name="WQ72"></a>D<br>A<br>T<br>E<br>
</th><th><a name="WQ73"></a>T<br>I<br>M<br>E<br>
</th><th><a name="WQ74"></a>T<br>I<br>M<br>E<br>S<br>T<br>A<br>M<br>P<br>
</th>
</tr>
<tr>
<td headers="WQ56" width="19%">SMALL INT</td><td headers="WQ57" width="5%">Y</td><td headers="WQ58" width="5%">Y</td><td headers="WQ59" width="5%">Y</td><td headers="WQ60" width="5%">Y</td><td headers="WQ61" width="4%">Y</td><td headers="WQ62" width="5%">Y</td><td headers="WQ63" width="5%">Y</td><td headers="WQ64" width="5%">--</td><td headers="WQ65" width="5%">--</td><td headers="WQ66" width="4%">--</td><td headers="WQ67" width="5%">--</td><td headers="WQ68" width="5%">--</td><td headers="WQ69" width="4%">--</td><td headers="WQ70" width="5%">--</td><td headers="WQ71" width="5%">--</td><td headers="WQ72" width="4%">--</td><td headers="WQ73" width="5%">--</td><td headers="WQ74" width="5%">--</td>
</tr>
<tr>
<td headers="WQ56" width="19%">INTEGER</td><td headers="WQ57" width="5%">Y</td><td headers="WQ58" width="5%">Y</td><td headers="WQ59" width="5%">Y</td><td headers="WQ60" width="5%">Y</td><td headers="WQ61" width="4%">Y</td><td headers="WQ62" width="5%">Y</td><td headers="WQ63" width="5%">Y</td><td headers="WQ64" width="5%">--</td><td headers="WQ65" width="5%">--</td><td headers="WQ66" width="4%">--</td><td headers="WQ67" width="5%">--</td><td headers="WQ68" width="5%">--</td><td headers="WQ69" width="4%">--</td><td headers="WQ70" width="5%">--</td><td headers="WQ71" width="5%">--</td><td headers="WQ72" width="4%">--</td><td headers="WQ73" width="5%">--</td><td headers="WQ74" width="5%">--</td>
</tr>
<tr>
<td headers="WQ56" width="19%">BIGINT</td><td headers="WQ57" width="5%">Y</td><td headers="WQ58" width="5%">Y</td><td headers="WQ59" width="5%">Y</td><td headers="WQ60" width="5%">Y</td><td headers="WQ61" width="4%">Y</td><td headers="WQ62" width="5%">Y</td><td headers="WQ63" width="5%">Y</td><td headers="WQ64" width="5%">--</td><td headers="WQ65" width="5%">--</td><td headers="WQ66" width="4%">--</td><td headers="WQ67" width="5%">--</td><td headers="WQ68" width="5%">--</td><td headers="WQ69" width="4%">--</td><td headers="WQ70" width="5%">--</td><td headers="WQ71" width="5%">--</td><td headers="WQ72" width="4%">--</td><td headers="WQ73" width="5%">--</td><td headers="WQ74" width="5%">--</td>
</tr>
<tr>
<td headers="WQ56" width="19%">DECIMAL</td><td headers="WQ57" width="5%">Y</td><td headers="WQ58" width="5%">Y</td><td headers="WQ59" width="5%">Y</td><td headers="WQ60" width="5%">Y</td><td headers="WQ61" width="4%">Y</td><td headers="WQ62" width="5%">Y</td><td headers="WQ63" width="5%">Y</td><td headers="WQ64" width="5%">--</td><td headers="WQ65" width="5%">--</td><td headers="WQ66" width="4%">--</td><td headers="WQ67" width="5%">--</td><td headers="WQ68" width="5%">--</td><td headers="WQ69" width="4%">--</td><td headers="WQ70" width="5%">--</td><td headers="WQ71" width="5%">--</td><td headers="WQ72" width="4%">--</td><td headers="WQ73" width="5%">--</td><td headers="WQ74" width="5%">--</td>
</tr>
<tr>
<td headers="WQ56" width="19%">REAL</td><td headers="WQ57" width="5%">Y</td><td headers="WQ58" width="5%">Y</td><td headers="WQ59" width="5%">Y</td><td headers="WQ60" width="5%">Y</td><td headers="WQ61" width="4%">Y</td><td headers="WQ62" width="5%">Y</td><td headers="WQ63" width="5%">Y</td><td headers="WQ64" width="5%">--</td><td headers="WQ65" width="5%">--</td><td headers="WQ66" width="4%">--</td><td headers="WQ67" width="5%">--</td><td headers="WQ68" width="5%">--</td><td headers="WQ69" width="4%">--</td><td headers="WQ70" width="5%">--</td><td headers="WQ71" width="5%">--</td><td headers="WQ72" width="4%">--</td><td headers="WQ73" width="5%">--</td><td headers="WQ74" width="5%">--</td>
</tr>
<tr>
<td headers="WQ56" width="19%">DOUBLE</td><td headers="WQ57" width="5%">Y</td><td headers="WQ58" width="5%">Y</td><td headers="WQ59" width="5%">Y</td><td headers="WQ60" width="5%">Y</td><td headers="WQ61" width="4%">Y</td><td headers="WQ62" width="5%">Y</td><td headers="WQ63" width="5%">Y</td><td headers="WQ64" width="5%">--</td><td headers="WQ65" width="5%">--</td><td headers="WQ66" width="4%">--</td><td headers="WQ67" width="5%">--</td><td headers="WQ68" width="5%">--</td><td headers="WQ69" width="4%">--</td><td headers="WQ70" width="5%">--</td><td headers="WQ71" width="5%">--</td><td headers="WQ72" width="4%">--</td><td headers="WQ73" width="5%">--</td><td headers="WQ74" width="5%">--</td>
</tr>
<tr>
<td headers="WQ56" width="19%">FLOAT</td><td headers="WQ57" width="5%">Y</td><td headers="WQ58" width="5%">Y</td><td headers="WQ59" width="5%">Y</td><td headers="WQ60" width="5%">Y</td><td headers="WQ61" width="4%">Y</td><td headers="WQ62" width="5%">Y</td><td headers="WQ63" width="5%">Y</td><td headers="WQ64" width="5%">--</td><td headers="WQ65" width="5%">--</td><td headers="WQ66" width="4%">--</td><td headers="WQ67" width="5%">--</td><td headers="WQ68" width="5%">--</td><td headers="WQ69" width="4%">--</td><td headers="WQ70" width="5%">--</td><td headers="WQ71" width="5%">--</td><td headers="WQ72" width="4%">--</td><td headers="WQ73" width="5%">--</td><td headers="WQ74" width="5%">--</td>
</tr>
<tr>
<td headers="WQ56" width="19%">CHAR</td><td headers="WQ57" width="5%">--</td><td headers="WQ58" width="5%">--</td><td headers="WQ59" width="5%">--</td><td headers="WQ60" width="5%">--</td><td headers="WQ61" width="4%">--</td><td headers="WQ62" width="5%">--</td><td headers="WQ63" width="5%">--</td><td headers="WQ64" width="5%">Y</td><td headers="WQ65" width="5%">Y</td><td headers="WQ66" width="4%">--</td><td headers="WQ67" width="5%">--</td><td headers="WQ68" width="5%">--</td><td headers="WQ69" width="4%">--</td><td headers="WQ70" width="5%">--</td><td headers="WQ71" width="5%">--</td><td headers="WQ72" width="4%">Y</td><td headers="WQ73" width="5%">Y</td><td headers="WQ74" width="5%">Y</td>
</tr>
<tr>
<td headers="WQ56" width="19%">VARCHAR</td><td headers="WQ57" width="5%">--</td><td headers="WQ58" width="5%">--</td><td headers="WQ59" width="5%">--</td><td headers="WQ60" width="5%">--</td><td headers="WQ61" width="4%">--</td><td headers="WQ62" width="5%">--</td><td headers="WQ63" width="5%">--</td><td headers="WQ64" width="5%">Y</td><td headers="WQ65" width="5%">Y</td><td headers="WQ66" width="4%">--</td><td headers="WQ67" width="5%">--</td><td headers="WQ68" width="5%">--</td><td headers="WQ69" width="4%">--</td><td headers="WQ70" width="5%">--</td><td headers="WQ71" width="5%">--</td><td headers="WQ72" width="4%">Y</td><td headers="WQ73" width="5%">Y</td><td headers="WQ74" width="5%">Y</td>
</tr>
<tr>
<td headers="WQ56" width="19%">LONG VARCHAR</td><td headers="WQ57" width="5%">--</td><td headers="WQ58" width="5%">--</td><td headers="WQ59" width="5%">--</td><td headers="WQ60" width="5%">--</td><td headers="WQ61" width="4%">--</td><td headers="WQ62" width="5%">--</td><td headers="WQ63" width="5%">--</td><td headers="WQ64" width="5%">--</td><td headers="WQ65" width="5%">--</td><td headers="WQ66" width="4%">--</td><td headers="WQ67" width="5%">--</td><td headers="WQ68" width="5%">--</td><td headers="WQ69" width="4%">--</td><td headers="WQ70" width="5%">--</td><td headers="WQ71" width="5%">--</td><td headers="WQ72" width="4%">--</td><td headers="WQ73" width="5%">--</td><td headers="WQ74" width="5%">--</td>
</tr>
<tr>
<td headers="WQ56" width="19%">CHAR FOR BIT DATA</td><td headers="WQ57" width="5%">--</td><td headers="WQ58" width="5%">--</td><td headers="WQ59" width="5%">--</td><td headers="WQ60" width="5%">--</td><td headers="WQ61" width="4%">--</td><td headers="WQ62" width="5%">--</td><td headers="WQ63" width="5%">--</td><td headers="WQ64" width="5%">--</td><td headers="WQ65" width="5%">--</td><td headers="WQ66" width="4%">--</td><td headers="WQ67" width="5%">Y</td><td headers="WQ68" width="5%">Y</td><td headers="WQ69" width="4%">--</td><td headers="WQ70" width="5%">--</td><td headers="WQ71" width="5%">--</td><td headers="WQ72" width="4%">--</td><td headers="WQ73" width="5%">--</td><td headers="WQ74" width="5%">--</td>
</tr>
<tr>
<td headers="WQ56" width="19%">VARCHAR FOR BIT DATA</td><td headers="WQ57" width="5%">--</td><td headers="WQ58" width="5%">--</td><td headers="WQ59" width="5%">--</td><td headers="WQ60" width="5%">--</td><td headers="WQ61" width="4%">--</td><td headers="WQ62" width="5%">--</td><td headers="WQ63" width="5%">--</td><td headers="WQ64" width="5%">--</td><td headers="WQ65" width="5%">--</td><td headers="WQ66" width="4%">--</td><td headers="WQ67" width="5%">Y</td><td headers="WQ68" width="5%">Y</td><td headers="WQ69" width="4%">--</td><td headers="WQ70" width="5%">--</td><td headers="WQ71" width="5%">--</td><td headers="WQ72" width="4%">--</td><td headers="WQ73" width="5%">--</td><td headers="WQ74" width="5%">--</td>
</tr>
<tr>
<td headers="WQ56" width="19%">LONG VARCHAR FOR BIT DATA</td><td headers="WQ57" width="5%">--</td><td headers="WQ58" width="5%">--</td><td headers="WQ59" width="5%">--</td><td headers="WQ60" width="5%">--</td><td headers="WQ61" width="4%">--</td><td headers="WQ62" width="5%">--</td><td headers="WQ63" width="5%">--</td><td headers="WQ64" width="5%">--</td><td headers="WQ65" width="5%">--</td><td headers="WQ66" width="4%">--</td><td headers="WQ67" width="5%">--</td><td headers="WQ68" width="5%">--</td><td headers="WQ69" width="4%">--</td><td headers="WQ70" width="5%">--</td><td headers="WQ71" width="5%">--</td><td headers="WQ72" width="4%">--</td><td headers="WQ73" width="5%">--</td><td headers="WQ74" width="5%">--</td>
</tr>
<tr>
<td headers="WQ56" width="19%">CLOB</td><td headers="WQ57" width="5%">--</td><td headers="WQ58" width="5%">--</td><td headers="WQ59" width="5%">--</td><td headers="WQ60" width="5%">--</td><td headers="WQ61" width="4%">--</td><td headers="WQ62" width="5%">--</td><td headers="WQ63" width="5%">--</td><td headers="WQ64" width="5%">--</td><td headers="WQ65" width="5%">--</td><td headers="WQ66" width="4%">--</td><td headers="WQ67" width="5%">--</td><td headers="WQ68" width="5%">--</td><td headers="WQ69" width="4%">--</td><td headers="WQ70" width="5%">--</td><td headers="WQ71" width="5%">--</td><td headers="WQ72" width="4%">--</td><td headers="WQ73" width="5%">--</td><td headers="WQ74" width="5%">--</td>
</tr>
<tr>
<td headers="WQ56" width="19%">BLOB</td><td headers="WQ57" width="5%">--</td><td headers="WQ58" width="5%">--</td><td headers="WQ59" width="5%">--</td><td headers="WQ60" width="5%">--</td><td headers="WQ61" width="4%">--</td><td headers="WQ62" width="5%">--</td><td headers="WQ63" width="5%">--</td><td headers="WQ64" width="5%">--</td><td headers="WQ65" width="5%">--</td><td headers="WQ66" width="4%">--</td><td headers="WQ67" width="5%">--</td><td headers="WQ68" width="5%">--</td><td headers="WQ69" width="4%">--</td><td headers="WQ70" width="5%">--</td><td headers="WQ71" width="5%">--</td><td headers="WQ72" width="4%">--</td><td headers="WQ73" width="5%">--</td><td headers="WQ74" width="5%">--</td>
</tr>
<tr>
<td headers="WQ56" width="19%">DATE</td><td headers="WQ57" width="5%">--</td><td headers="WQ58" width="5%">--</td><td headers="WQ59" width="5%">--</td><td headers="WQ60" width="5%">--</td><td headers="WQ61" width="4%">--</td><td headers="WQ62" width="5%">--</td><td headers="WQ63" width="5%">--</td><td headers="WQ64" width="5%">Y</td><td headers="WQ65" width="5%">Y</td><td headers="WQ66" width="4%">--</td><td headers="WQ67" width="5%">--</td><td headers="WQ68" width="5%">--</td><td headers="WQ69" width="4%">--</td><td headers="WQ70" width="5%">--</td><td headers="WQ71" width="5%">--</td><td headers="WQ72" width="4%">Y</td><td headers="WQ73" width="5%">--</td><td headers="WQ74" width="5%">--</td>
</tr>
<tr>
<td headers="WQ56" width="19%">TIME</td><td headers="WQ57" width="5%">--</td><td headers="WQ58" width="5%">--</td><td headers="WQ59" width="5%">--</td><td headers="WQ60" width="5%">--</td><td headers="WQ61" width="4%">--</td><td headers="WQ62" width="5%">--</td><td headers="WQ63" width="5%">--</td><td headers="WQ64" width="5%">Y</td><td headers="WQ65" width="5%">Y</td><td headers="WQ66" width="4%">--</td><td headers="WQ67" width="5%">--</td><td headers="WQ68" width="5%">--</td><td headers="WQ69" width="4%">--</td><td headers="WQ70" width="5%">--</td><td headers="WQ71" width="5%">--</td><td headers="WQ72" width="4%">--</td><td headers="WQ73" width="5%">Y</td><td headers="WQ74" width="5%">--</td>
</tr>
<tr>
<td headers="WQ56" width="19%">TIME STAMP</td><td headers="WQ57" width="5%">--</td><td headers="WQ58" width="5%">--</td><td headers="WQ59" width="5%">--</td><td headers="WQ60" width="5%">--</td><td headers="WQ61" width="4%">--</td><td headers="WQ62" width="5%">--</td><td headers="WQ63" width="5%">--</td><td headers="WQ64" width="5%">Y</td><td headers="WQ65" width="5%">Y</td><td headers="WQ66" width="4%">--</td><td headers="WQ67" width="5%">--</td><td headers="WQ68" width="5%">--</td><td headers="WQ69" width="4%">--</td><td headers="WQ70" width="5%">--</td><td headers="WQ71" width="5%">--</td><td headers="WQ72" width="4%">--</td><td headers="WQ73" width="5%">--</td><td headers="WQ74" width="5%">Y</td>
</tr>
</table>
<hr>
<a href="sqlj124.html">Previous Page</a>
<br>
<a href="sqlj126.html">Next Page</a>
<br>
<a href="sqlj02.html#ToC">Table of Contents</a>
<br>
<a href="sqlj275.html#HDRINDEX_START">Index</a>
</div>
<div class="attribution"></div>
</div>
</td><td width="10"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<!--================= end Content==================-->
</table>
</td>
</tr>
</table>
<!--================= end Menu, NavBar, Content ==================-->
<!--================= start Footer ==================-->
<table summary="footer" cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td colspan="2" height="1" bgcolor="#4C6C8F"><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"><a href="../../skin/images/label.gif"></a><a href="../../skin/images/page.gif"></a><a href="../../skin/images/chapter.gif"></a><a href="../../skin/images/chapter_open.gif"></a><a href="../../skin/images/current.gif"></a><a href="/favicon.ico"></a></td>
</tr>
<tr>
<td colspan="2" bgcolor="#CFDCED" class="copyright" align="center"><font size="2" face="Arial, Helvetica, Sans-Serif">Copyright &copy;
          2004&nbsp;Apache Software Foundation All rights reserved.<script type="text/javascript" language="JavaScript"><!--
              document.write(" - "+"Last Published: " + document.lastModified);
            //  --></script></font></td>
</tr>
<tr>
<td colspan="2" align="left" bgcolor="#CFDCED" class="logos"></td>
</tr>
</table>
<!--================= end Footer ==================-->
</body>
</html>
